Release 10.1A: OpenEdge Data Management:
SQL Reference

MAX

Returns the maximum value in a group of values.

Syntax

COUNT ( { [ ALL ] expression } | { DISTINCT column_ref } | * )

Example

This example illustrates the MAX function:

SELECT order_date, product, MAX (qty) FROM orders GROUP BY order_date, product ;

Notes

Specifying DISTINCT has no effect on the result.
The argument column_ref or expression can be of any type.
The result of the function is of the same data type as that of the argument.
The result is NULL if the result set is empty or contains only NULL values.